[dbo].[asi_UpdatePublishedRuleDebugMode]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_UpdatePublishedRuleDebugMode

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@objectName	nvarchar(100)	200
@enableDebug	bit	1
@debugFile	nvarchar(250)	500

SQL Script

CREATE PROCEDURE [dbo].[asi_UpdatePublishedRuleDebugMode]

@objectName nvarchar(100),
@enableDebug bit,
@debugFile nvarchar(250) = NULL

AS

UPDATE RuleSourcePublish SET IsDebugEnabled = @enableDebug, DebugFileName = @debugFile WHERE RuleName = @objectName

GO

Uses

[dbo].[RuleSourcePublish]
dbo